USE [ObliDisenoAplicaciones]
GO
/****** Object:  Table [dbo].[Diseno]    Script Date: 06/07/2013 16:50:42 ******/
INSERT [dbo].[Diseno] ([Oid], [Nombre], [Descripcion], [Costo], [CostoAgregado], [FechaService], [Medio]) VALUES (1, N'R&N-001', N'Terrestre', CAST(154.81 AS Decimal(18, 2)), CAST(12.00 AS Decimal(18, 2)), CAST(0x0000A1B601150955 AS DateTime), N'Terrestre')
INSERT [dbo].[Diseno] ([Oid], [Nombre], [Descripcion], [Costo], [CostoAgregado], [FechaService], [Medio]) VALUES (2, N'R&N-003', N'Terrestre', CAST(432.43 AS Decimal(18, 2)), CAST(4.00 AS Decimal(18, 2)), CAST(0x0000A1B601150955 AS DateTime), N'Terrestre')
INSERT [dbo].[Diseno] ([Oid], [Nombre], [Descripcion], [Costo], [CostoAgregado], [FechaService], [Medio]) VALUES (3, N'R&N-002', N'Terrestre', CAST(148.81 AS Decimal(18, 2)), CAST(6.00 AS Decimal(18, 2)), CAST(0x0000A1B601150955 AS DateTime), N'Terrestre')
INSERT [dbo].[Diseno] ([Oid], [Nombre], [Descripcion], [Costo], [CostoAgregado], [FechaService], [Medio]) VALUES (4, N'R&N-006', N'Acuatico', CAST(2170.98 AS Decimal(18, 2)), CAST(3.00 AS Decimal(18, 2)), CAST(0x0000A1A70115099B AS DateTime), N'Acuatico')
INSERT [dbo].[Diseno] ([Oid], [Nombre], [Descripcion], [Costo], [CostoAgregado], [FechaService], [Medio]) VALUES (5, N'R&N-007', N'Acuatico', CAST(7163.50 AS Decimal(18, 2)), CAST(31.00 AS Decimal(18, 2)), CAST(0x0000A1A70115099B AS DateTime), N'Acuatico')
/****** Object:  Table [dbo].[Componentes]    Script Date: 06/07/2013 16:50:42 ******/
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (1, N'TOR-6', N'PIE-TOR006', N'Tornillo cabeza cuadrada 6 '''' ', N'Terrestre', CAST(11.56 AS Decimal(18, 2)), 40, CAST(0x0000A1B601150955 AS DateTime), CAST(0x0000A1D301150955 AS DateTime), NULL, CAST(44.56 AS Decimal(18, 2)), NULL, NULL, 0, N'PiezaTerrestre')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (2, N'TOR-10', N'PIE-TOR0010', N'Tornillo cabeza cuadrada 10 '''' ', N'Terrestre', CAST(11.56 AS Decimal(18, 2)), 100, CAST(0x0000A1B60115097E AS DateTime), CAST(0x0000A1D40115097E AS DateTime), NULL, CAST(41.56 AS Decimal(18, 2)), NULL, NULL, 0, N'PiezaTerrestre')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (3, N'TOR-20', N'PIE-TOR0020', N'Tornillo cabeza cuadrada 20 '''' ', N'Terrestre', CAST(11.00 AS Decimal(18, 2)), 60, CAST(0x0000A1F501150981 AS DateTime), CAST(0x0000A1B501150981 AS DateTime), NULL, CAST(14.53 AS Decimal(18, 2)), NULL, NULL, 0, N'PiezaTerrestre')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (4, N'VIS-13', N'PIE-VIS0013', N'Visagra doble chica ', N'Terrestre', CAST(12.44 AS Decimal(18, 2)), 102, CAST(0x0000A1AD01150983 AS DateTime), CAST(0x0000A18301150983 AS DateTime), NULL, CAST(13.56 AS Decimal(18, 2)), NULL, NULL, 0, N'PiezaTerrestre')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (5, N'VIS-15', N'PIE-VIS0015', N'Visagra triple chica ', N'Terrestre', CAST(101.26 AS Decimal(18, 2)), 60, CAST(0x0000A1F801150986 AS DateTime), CAST(0x0000A1CE01150986 AS DateTime), NULL, CAST(24.26 AS Decimal(18, 2)), NULL, NULL, 0, N'PiezaTerrestre')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (6, N'RUE-13', N'PIE-RUE0013', N'Rueda rodado 13', N'Terrestre', CAST(110.00 AS Decimal(18, 2)), 60, CAST(0x0000A1EC01150989 AS DateTime), CAST(0x0000A1CF01150989 AS DateTime), NULL, CAST(44.22 AS Decimal(18, 2)), NULL, NULL, 0, N'PiezaTerrestre')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (7, N'RUE-15', N'PIE-RUE0015', N'Rueda rodado 15', N'Terrestre', CAST(54.00 AS Decimal(18, 2)), 110, CAST(0x0000A1D30115098C AS DateTime), CAST(0x0000A1CE0115098C AS DateTime), NULL, CAST(12.21 AS Decimal(18, 2)), NULL, NULL, 0, N'PiezaTerrestre')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (8, N'RUE-17', N'PIE-RUE0017', N'Rueda rodado 17', N'Terrestre', CAST(29.99 AS Decimal(18, 2)), 140, CAST(0x0000A1E20115098F AS DateTime), CAST(0x0000A1D10115098F AS DateTime), NULL, CAST(21.51 AS Decimal(18, 2)), NULL, NULL, 0, N'PiezaTerrestre')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (9, N'VEL-19', N'PIE-VEL0019', N'Vela Central', N'Acuatico', CAST(222.99 AS Decimal(18, 2)), 50, CAST(0x0000A20601150992 AS DateTime), CAST(0x0000A19101150992 AS DateTime), CAST(23.56 AS Decimal(18, 2)), NULL, NULL, NULL, 0, N'PiezaAcuatica')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (10, N'VEL-8', N'PIE-VEL0008', N'Vela Frontal', N'Acuatico', CAST(355.00 AS Decimal(18, 2)), 150, CAST(0x0000A1AD01150995 AS DateTime), CAST(0x0000A19101150995 AS DateTime), CAST(23.56 AS Decimal(18, 2)), NULL, NULL, NULL, 0, N'PiezaAcuatica')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (11, N'FLO-11', N'PIE-FLO0011', N'Flotador Lateral', N'Acuatico', CAST(324.99 AS Decimal(18, 2)), 70, CAST(0x0000A20201150998 AS DateTime), CAST(0x0000A19101150998 AS DateTime), CAST(23.56 AS Decimal(18, 2)), NULL, NULL, NULL, 0, N'PiezaAcuatica')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (12, N'FLO-12', N'PIE-FLO0012', N'Flotador Principal', N'Acuatico', CAST(84.00 AS Decimal(18, 2)), 210, CAST(0x0000A1A70115099B AS DateTime), CAST(0x0000A1910115099B AS DateTime), CAST(23.56 AS Decimal(18, 2)), NULL, NULL, NULL, 0, N'PiezaAcuatica')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (13, N'ANC-61', N'PIE-ANC0061', N'Ancla 25kg', N'Acuatico', CAST(67.00 AS Decimal(18, 2)), 80, CAST(0x0000A2070115099D AS DateTime), CAST(0x0000A1910115099D AS DateTime), CAST(23.56 AS Decimal(18, 2)), NULL, NULL, NULL, 0, N'PiezaAcuatica')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (14, N'ANC-77', N'PIE-ANC0077', N'Ancla 80kg', N'Acuatico', CAST(769.50 AS Decimal(18, 2)), 105, CAST(0x0000A208011509A0 AS DateTime), CAST(0x0000A191011509A0 AS DateTime), CAST(23.56 AS Decimal(18, 2)), NULL, NULL, NULL, 0, N'PiezaAcuatica')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (15, N'ALA-01', N'PIE-ALA01', N'Ala Lateral', N'Aereo', CAST(17.99 AS Decimal(18, 2)), 3, CAST(0x0000A206011509A3 AS DateTime), CAST(0x0000A1D0011509A3 AS DateTime), NULL, NULL, CAST(71.56 AS Decimal(18, 2)), CAST(12.88 AS Decimal(18, 2)), 0, N'PiezaAerea')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (16, N'ALA-03', N'PIE-ALA03', N'Ala Lateral Grande', N'Aereo', CAST(25.99 AS Decimal(18, 2)), 50, CAST(0x0000A1D8011509A6 AS DateTime), CAST(0x0000A1CE011509A6 AS DateTime), NULL, NULL, CAST(71.56 AS Decimal(18, 2)), CAST(12.88 AS Decimal(18, 2)), 0, N'PiezaAerea')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (17, N'ALA-05', N'PIE-ALA05', N'Ala Lateral Chica', N'Aereo', CAST(45.99 AS Decimal(18, 2)), 20, CAST(0x0000A1C6011509A9 AS DateTime), CAST(0x0000A1D4011509A9 AS DateTime), NULL, NULL, CAST(100.56 AS Decimal(18, 2)), CAST(12.88 AS Decimal(18, 2)), 0, N'PiezaAerea')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (18, N'TUR-77', N'PIE-TUR77', N'Turbina Lateral', N'Aereo', CAST(80.99 AS Decimal(18, 2)), 20, CAST(0x0000A1F2011509AC AS DateTime), CAST(0x0000A1CA011509AC AS DateTime), NULL, NULL, CAST(120.56 AS Decimal(18, 2)), CAST(112.88 AS Decimal(18, 2)), 0, N'PiezaAerea')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (19, N'TUR-99', N'PIE-TUR99', N'Turbina Lateral', N'Aereo', CAST(12.99 AS Decimal(18, 2)), 220, CAST(0x0000A1B8011509AF AS DateTime), CAST(0x0000A1C8011509AF AS DateTime), NULL, NULL, CAST(120.56 AS Decimal(18, 2)), CAST(112.88 AS Decimal(18, 2)), 0, N'PiezaAerea')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (20, N'HON-01', N'ROB-HON0001', N'Buscador Marino', N'Acuatico', CAST(422.00 AS Decimal(18, 2)), 50, CAST(0x0000A1E6011509B2 AS DateTime), CAST(0x0000A191011509B2 AS DateTime), NULL, NULL, NULL, NULL, 0, N'Robot')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (21, N'HON-02', N'ROB-HON0002', N'Escabador SubAcuatico', N'Acuatico', CAST(861.00 AS Decimal(18, 2)), 50, CAST(0x0000A1DE011509C2 AS DateTime), CAST(0x0000A191011509C2 AS DateTime), NULL, NULL, NULL, NULL, 0, N'Robot')
INSERT [dbo].[Componentes] ([Oid], [Modelo], [NumeroSerie], [Descripcion], [Medio], [Costo], [Cantidad], [FechaService], [FechaCreacion], [Profundidad], [Temperatura], [Altitud], [Velocidad], [Eliminado], [TipoComponente]) VALUES (22, N'AIR-77', N'ROB-AIR0777', N'Avion 777', N'Aereo', CAST(1700.00 AS Decimal(18, 2)), 50, CAST(0x0000A1F0011509DC AS DateTime), CAST(0x0000A169011509DC AS DateTime), NULL, NULL, NULL, NULL, 0, N'Robot')
/****** Object:  Table [dbo].[Produccion]    Script Date: 06/07/2013 16:50:42 ******/
/****** Object:  Table [dbo].[DisenoComponente]    Script Date: 06/07/2013 16:50:42 ******/
INSERT [dbo].[DisenoComponente] ([IdDiseno], [IdComponente], [CantidadComp]) VALUES (1, 1, 1)
INSERT [dbo].[DisenoComponente] ([IdDiseno], [IdComponente], [CantidadComp]) VALUES (1, 5, 1)
INSERT [dbo].[DisenoComponente] ([IdDiseno], [IdComponente], [CantidadComp]) VALUES (1, 8, 1)
INSERT [dbo].[DisenoComponente] ([IdDiseno], [IdComponente], [CantidadComp]) VALUES (2, 1, 3)
INSERT [dbo].[DisenoComponente] ([IdDiseno], [IdComponente], [CantidadComp]) VALUES (2, 5, 3)
INSERT [dbo].[DisenoComponente] ([IdDiseno], [IdComponente], [CantidadComp]) VALUES (2, 8, 3)
INSERT [dbo].[DisenoComponente] ([IdDiseno], [IdComponente], [CantidadComp]) VALUES (3, 1, 1)
INSERT [dbo].[DisenoComponente] ([IdDiseno], [IdComponente], [CantidadComp]) VALUES (3, 5, 1)
INSERT [dbo].[DisenoComponente] ([IdDiseno], [IdComponente], [CantidadComp]) VALUES (3, 8, 1)
INSERT [dbo].[DisenoComponente] ([IdDiseno], [IdComponente], [CantidadComp]) VALUES (4, 11, 2)
INSERT [dbo].[DisenoComponente] ([IdDiseno], [IdComponente], [CantidadComp]) VALUES (4, 12, 3)
INSERT [dbo].[DisenoComponente] ([IdDiseno], [IdComponente], [CantidadComp]) VALUES (4, 20, 3)
INSERT [dbo].[DisenoComponente] ([IdDiseno], [IdComponente], [CantidadComp]) VALUES (5, 12, 4)
INSERT [dbo].[DisenoComponente] ([IdDiseno], [IdComponente], [CantidadComp]) VALUES (5, 14, 1)
INSERT [dbo].[DisenoComponente] ([IdDiseno], [IdComponente], [CantidadComp]) VALUES (5, 21, 7)
/****** Object:  Table [dbo].[ComponenteComp]    Script Date: 06/07/2013 16:50:42 ******/
INSERT [dbo].[ComponenteComp] ([IdComponentePadre], [IdComponenteHijo], [CantidadComp]) VALUES (20, 10, 15)
INSERT [dbo].[ComponenteComp] ([IdComponentePadre], [IdComponenteHijo], [CantidadComp]) VALUES (20, 13, 8)
INSERT [dbo].[ComponenteComp] ([IdComponentePadre], [IdComponenteHijo], [CantidadComp]) VALUES (21, 10, 15)
INSERT [dbo].[ComponenteComp] ([IdComponentePadre], [IdComponenteHijo], [CantidadComp]) VALUES (21, 12, 21)
INSERT [dbo].[ComponenteComp] ([IdComponentePadre], [IdComponenteHijo], [CantidadComp]) VALUES (21, 20, 5)
INSERT [dbo].[ComponenteComp] ([IdComponentePadre], [IdComponenteHijo], [CantidadComp]) VALUES (22, 17, 2)
INSERT [dbo].[ComponenteComp] ([IdComponentePadre], [IdComponenteHijo], [CantidadComp]) VALUES (22, 18, 2)
INSERT [dbo].[ComponenteComp] ([IdComponentePadre], [IdComponenteHijo], [CantidadComp]) VALUES (22, 19, 22)